SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'BORN ON DERBY DAY'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '15.476'
ORDER BY results_barrel_races.earnings DESC
1)
15.476
$1,202.00
Andrea Busby
BORN ON DERBY DAY
FRECKLES TA FAME x KR Last Fling
(A STREAK OF FLING)
Open 5D
1D 1 15.476
$710.00
Best In The West
1D 1 15.476
$384.00
Adult Sidepot
1D 1 15.476
$108.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'AMISH RAIN'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '15.566'
ORDER BY results_barrel_races.earnings DESC
2)
15.566
$498.00
Tiany Schuster
AMISH RAIN
Moonland Jess x Frans Easter Sunday
(Brisco County Jr)
Open 5D
1D 2 15.566
$426.00
Adult Sidepot
1D 2 15.566
$72.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'FAMOUS DALLAS JAZZ'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '15.612'
ORDER BY results_barrel_races.earnings DESC
3)
15.612
$284.00
Ivy Hurst
FAMOUS DALLAS JAZZ
DALLAS FUEL x Mistys Dash Of Fame
(Dash Ta Fame)
Open 5D
1D 3 15.612
$284.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'SHOOTINFORFAMOUS'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '15.893'
ORDER BY results_barrel_races.earnings DESC
4)
15.893
$36.00
Hannah Ripley
SHOOTINFORFAMOUS
JB PROUD N FAMOUS x Dashing Valismy Name
Youth Sidepot
1D 1 15.893
$36.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'MC Sheza Fast Grand'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '15.992'
ORDER BY results_barrel_races.earnings DESC
5)
15.992
$581.00
Deb Shefveland
MC Sheza Fast Grand
Open 5D
2D 1 15.992
$581.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'Big Iron'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '16.038'
ORDER BY results_barrel_races.earnings DESC
6)
16.038
$408.00
Kelly Bruner
Big Iron
Open 5D
2D 2 16.038
$348.00
Senior Sidepot
1D 1 16.038
$60.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'BLAZING WITH MY DUDE'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '16.045'
ORDER BY results_barrel_races.earnings DESC
7)
16.045
$553.00
Andrea Busby
BLAZING WITH MY DUDE
Best In The West
2D 1 16.045
$256.00
Open 5D
2D 3 16.045
$232.00
Adult Sidepot
2D 1 16.045
$65.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'Dual Hand Luke'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '16.060'
ORDER BY results_barrel_races.earnings DESC
8)
16.060
Jessica Watkins
Dual Hand Luke
Open 5D
2D 16.060
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'FURYTYME'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '16.067'
ORDER BY results_barrel_races.earnings DESC
9)
16.067
$43.00
Fallon Taylor
FURYTYME
FURYOFTHEWIND x Three Tymes A Lady
(Tres Seis)
Adult Sidepot
2D 2 16.067
$43.00
SELECT results_barrel_races.division,
results_barrel_races.go_avg,
results_barrel_races.placing,
results_barrel_races.time,
results_barrel_races.earnings,
results_barrel_races.class_name,
SUM(results_barrel_races.earnings) OVER () AS total_earnings
FROM
results_barrel_races
WHERE
results_barrel_races.r_horse_name = 'Talented Angel'
AND results_barrel_races.eventid_results = '73'
AND results_barrel_races.time = '16.116'
ORDER BY results_barrel_races.earnings DESC